SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415112 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415112 [ RunTime:0.002717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841528,457168,257146,439455,1028221,740086,94332,342321,453266,963312,517921,259226,556721,449692,669840,800562,208889,988634,814425,836249,972717,960750,657300,119585,805330,521779,333124,1001303,388759,260430,891917,120421,114357,546213,230233,324155,454794,861829,250359,525700,708880,453201,668707,1016755,438563,295420,499301,986426,369892,212864,133485,198559,319588,404479,269767,336662,152494,248012,699643,680038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]