SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110404 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110404 [ RunTime:0.002924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205730,840115,204490,647835,681012,163068,1008308,548240,869930,85407,55529,231287,364207,218426,263230,1004737,237508,345608,11276,439047,426541,662724,848900,954395,245965,50489,715880,410826,219660,538092,255445,996623,554424,161762,910281,933165,660478,45422,441966,684435,1000492,53855,865845,1048726,432421,869595,245620,71186,658131,926088,9857,576109,835842,641001,612632,546285,208000,181687,621480,42477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]