SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046409 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046409 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184582,416343,635451,761694,402788,240488,383841,481505,1013585,421935,292757,601582,106899,740686,729974,160049,81691,364188,860550,263577,631126,692013,691778,553013,280929,577204,160364,822331,299294,65499,810602,487116,325133,91615,907875,491183,733742,706624,460924,766153,313399,713842,16497,42386,641200,752575,314882,455002,820258,124759,649346,463065,129240,395422,606326,30671,653881,1038689,250523,283489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]