SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041283 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041283 [ RunTime:0.003152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871936,406974,898145,895391,94235,835554,573244,755779,833420,421634,224175,790813,200405,45127,126472,324598,501843,407606,621624,277000,966244,4005,203036,722423,681760,483216,173700,1002124,972094,491530,660316,389109,759672,326729,270515,290630,924968,304929,51318,219235,2598,2557,874109,663018,609892,182349,45987,375103,253931,518790,239691,977379,189038,597599,532113,319571,573663,262667,41713,1028228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]