SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522380 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522380 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687578,577799,36135,118957,889462,798414,67832,483731,615232,660919,110716,710411,698974,371700,779448,597584,26939,89139,185093,55810,596175,825874,443954,577402,462767,681296,525674,289713,617940,182604,419584,44575,650612,270996,773407,1020122,280237,570565,203475,535184,1029589,470112,198384,115441,619389,952937,1002100,914937,814744,392822,998435,1012185,763785,1015003,478550,172575,940225,802268,1012038,254971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]