SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528126 LIMIT 1 [ RunTime:0.001128s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528126 [ RunTime:0.002109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383096,991654,508217,393826,8475,268759,60758,479094,3786,381976,540586,403471,6368,166772,84831,318513,738354,142967,566611,779535,1015240,727458,838,607824,729952,272259,467701,300506,933360,598241,435666,852911,777455,812888,810396,203985,118443,638632,1018770,429806,300001,681055,2742,478053,726456,1012482,565956,771859,951287,776728,614662,577568,157814,907556,868070,782752,458992,408717,723293,428231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528126 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528126 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]