SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574505 LIMIT 1 [ RunTime:0.002376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574505 [ RunTime:0.002268s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841699,448680,789563,98045,803177,779318,737161,687837,681949,372763,137144,605098,581919,540625,229747,239684,358977,749696,668879,902980,123182,159940,624939,470723,77134,939385,100217,120066,107316,527639,591262,836119,759865,520038,596948,944130,973810,611177,289624,49756,387875,746687,786326,664827,474205,839147,521859,951008,47471,966306,945696,859188,851275,652247,133825,398493,99447,1048168,35132,99) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574505 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574505 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]