SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106791 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106791 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026548,348241,69972,85162,335542,477494,669083,1012230,641641,299855,216880,74102,177988,645863,1036794,944961,846418,784806,76991,722472,626677,562290,349746,330309,235024,279592,959432,451995,18380,501283,736176,244882,557231,11757,666911,110372,851690,230364,936698,551508,939245,950870,1038660,87848,411347,299075,364793,139546,341369,522817,512496,940096,261910,941460,520972,403845,864085,634403,816136,831324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]