SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 32023 LIMIT 1 [ RunTime:0.000579s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 32023 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (638090,221881,108953,856023,190054,980918,857257,1042104,685799,765267,153298,361208,952868,268631,939914,883216,89703,424354,538387,583450,19229,839540,1015521,1039220,847324,1004392,697896,730541,513151,33198,758833,955654,859489,448033,791912,827122,1047112,466906,457627,1046272,180910,167617,177152,1030767,579287,781817,66728,60373,464994,325577,300485,342325,732346,1010328,804943,271952,345339,1046888,686406,764616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 32023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 32023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]