SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001731s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403309 LIMIT 1 [ RunTime:0.001125s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403309 [ RunTime:0.005138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926682,239543,31752,1009373,746979,232966,501721,428658,751772,532377,193419,725142,632898,299478,603934,479583,382817,945538,40075,140191,444633,468921,945073,981701,830127,291074,146509,1023557,349925,382327,95813,1024271,764193,4120,48888,874020,948529,80175,318467,334593,278361,217820,195302,751890,475508,384348,926627,764931,513850,378750,463289,1003899,899678,345016,285225,621086,1046497,486532,891046,205274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]