SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010173 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010173 [ RunTime:0.002434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670475,676695,968445,570797,108999,1507,1001726,1008221,448732,418099,194172,429463,543909,493840,215112,193121,702878,366656,417715,941647,1040221,196942,160274,650832,98112,836738,322273,244307,640421,634736,640615,483306,1010842,870982,295553,44068,10680,864541,348401,662767,74241,141319,87902,359667,99172,680483,1044816,986688,335306,715558,733481,951595,255911,735600,845602,132787,213448,287113,625924,454905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010173 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010173 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]