SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001686s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 678441 LIMIT 1 [ RunTime:0.000547s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 678441 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284611,732006,472716,505305,763073,235988,304327,453855,343702,159270,20722,655015,548764,160324,410175,879146,907806,362122,928673,201149,845781,302140,959172,732338,308263,629261,128136,857030,106140,883437,523902,809466,286136,256935,231679,383563,3520,800905,959862,462760,857597,667198,781333,911570,734472,917172,265700,525850,884053,211120,935353,504842,460231,33544,537125,812416,682410,417338,494746,166437) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 678441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 678441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001737s ]