SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447960 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447960 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (834850,384093,75641,133355,36136,692764,117992,327125,874830,47330,499334,108708,852725,956688,191546,998264,40281,20310,130848,1019405,333517,137041,1008715,565124,310061,270255,368156,985341,108522,440310,512333,132563,381652,98990,294876,279945,322626,225678,500645,423613,921083,962655,563515,974831,524677,922523,799168,869265,858737,648108,1014989,354456,596750,564676,167608,89148,815667,383408,922381,971146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]