SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404597 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404597 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492537,513289,606579,683351,681381,173048,727946,472142,883835,220021,482608,675713,305610,9962,421068,266534,27529,847726,1001023,632909,125006,291493,905985,332310,315557,436587,693428,488922,877929,93879,194030,771678,127542,591733,357562,654836,203781,759648,705738,945188,976541,194571,789366,781154,366443,799714,1047174,77126,988118,190888,122207,797836,727281,736143,828760,713225,567047,926579,554043,982917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404597 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404597 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]