SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 651822 LIMIT 1 [ RunTime:0.001290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 651822 [ RunTime:0.002171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516282,540272,550704,879009,535940,508805,842240,607589,202549,524742,563978,637380,662677,255997,950514,737605,324107,826199,50651,748827,698785,812069,112522,80410,633213,868123,928473,474288,956879,580324,887702,468588,198163,1010835,386805,41456,162564,691999,24219,936983,269499,936790,764460,958653,960996,316765,842828,276017,757722,195804,566448,168292,536836,486975,410582,460119,948617,395555,916655,784941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 651822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 651822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]