SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806844 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806844 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595424,1042530,835848,980001,814332,426567,508581,363151,578290,493489,419990,180244,270467,473756,85838,968931,578653,1007108,835762,321101,1038595,680786,634155,1015111,397059,960047,268239,416741,844970,372620,140805,1043595,658934,394234,222888,302747,1032070,845905,622390,308823,973863,670742,849928,1027712,442750,211745,1010267,785205,49600,530052,753993,816253,545602,503953,90633,279538,43139,781799,56944,49283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]