SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436856 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436856 [ RunTime:0.002403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434481,1020461,111983,860658,161063,255042,477589,627510,830667,616234,696541,793367,630784,428461,282647,760077,328944,979738,118098,1045304,854538,641595,1023150,741207,345440,960671,6703,650226,513596,682957,139367,604344,931139,250044,203074,473465,119431,489474,968623,1026359,243758,1014158,714734,49209,443369,258094,942965,477298,331328,355231,334880,524864,725806,35023,799763,259093,604657,593634,481869,66803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]