SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021796 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021796 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612241,1047579,728999,458299,790404,939988,101145,717662,857910,714123,805445,471624,901288,531173,218842,14594,683835,670353,333654,280762,133416,228595,280570,445288,886874,414824,459066,427168,319871,637279,426126,490017,842022,984073,506932,733841,6807,928012,390311,908373,657145,13518,223749,196614,40621,169725,441488,667633,1015232,57382,138935,314187,245537,65552,810974,182396,671741,614407,532645,713498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]