SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010490 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010490 [ RunTime:0.002135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926070,926314,1026572,674215,542830,225704,378752,636052,601536,29165,544833,625426,691094,799330,517197,13468,889592,989908,645293,497562,568672,140526,909093,917688,429447,679369,991422,195097,259375,528666,121052,286755,428477,492811,196065,827952,821304,217952,983373,446937,981915,1040088,136737,705841,898055,315404,653131,637358,514871,920417,69205,631880,751556,329772,351842,442361,641516,724077,15747,52957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]