SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002068s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 922815 LIMIT 1 [ RunTime:0.000860s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 922815 [ RunTime:0.002615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349529,928402,726425,343384,128672,973432,1029421,632150,119623,360431,308417,982332,1018787,603114,612420,110496,361325,971065,935063,287448,254485,95663,239969,492160,313400,308080,703824,462282,173583,178609,401799,673867,303440,658136,824610,901681,735888,839010,386521,200762,479693,218069,592238,198599,925010,304970,132737,204805,949663,572849,671118,938767,390780,244062,478778,726563,910316,358813,33339,513587) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 922815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 922815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]