SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001490s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106504 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106504 [ RunTime:0.004876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421705,872143,398719,1044677,971797,330537,980869,44724,690878,14877,943287,921262,270687,508169,699048,1037670,470780,85928,270614,241701,567554,624778,82482,914076,1027620,674085,119540,945047,714248,661613,799722,673297,619785,729023,461172,872885,962915,317234,895313,563228,20624,572403,228591,379235,1031840,544667,1046943,715472,217116,207117,79052,633110,143578,56978,593348,876823,295735,268910,993581,278532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]