SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424550 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424550 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (779445,1013207,680818,752163,444140,410320,621305,886765,428136,801406,724910,40668,859017,737841,478279,356896,471487,921149,702038,292937,1006844,954188,191589,250390,263240,1029570,168019,446393,712174,596700,29312,214548,269977,420456,1004237,937141,215760,112850,1014781,399762,12020,364726,185681,158606,715925,943967,618983,741468,679790,381695,172545,1011095,769768,1016797,405865,89651,718237,664354,839744,416951) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]