SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520015 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520015 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014298,1020179,209747,1021080,820968,664121,396701,614839,637440,120916,379136,476749,50997,745024,905809,749907,841186,184719,612915,335422,57951,854852,180831,575434,371206,728141,190695,59429,743944,654082,303402,502342,709402,931515,169489,958921,800086,642000,749560,944720,541835,166444,540201,315783,194064,775570,199803,665728,7454,656167,293708,815723,894312,407046,489485,108988,200143,302885,1044488,400360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]