SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427633 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427633 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (682671,603262,552494,460818,641749,205865,245423,78627,1036649,902746,980713,810627,608580,364330,87598,45656,497931,290315,682590,235651,654900,898089,488629,928770,859918,869294,177320,387669,403991,432952,36862,672190,85917,336756,335383,512413,66801,280712,152443,272922,472814,714034,106887,554500,342095,590003,451607,59424,810048,640516,693289,55626,712488,565417,293657,611284,656822,345318,364063,822787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427633 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427633 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]