SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526086 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526086 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032678,406762,449489,1048363,532666,975459,531290,510996,306143,485235,752549,33496,297441,19840,743095,189494,195342,909518,815484,43683,650835,106841,416111,574457,1008689,105853,693427,600419,67023,164441,491599,735954,124423,107877,891347,60047,873585,761403,856098,553200,168239,516173,9959,427598,1035202,223365,48332,798760,956372,47384,803555,1016527,14493,149587,99992,116168,426404,16346,68305,230421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]