SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565905 LIMIT 1 [ RunTime:0.001239s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565905 [ RunTime:0.002558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412944,69147,433888,424122,616220,1019256,939982,951608,971954,746912,1021885,447113,352812,608788,671900,374486,388250,1048503,954813,935580,875837,586145,789180,864315,1019154,812949,908323,963804,452801,336757,971484,631421,1038338,561141,505327,37144,392256,913788,988879,349151,824374,350727,895340,683267,867855,127498,764890,492139,797937,720139,967350,543259,328450,698308,600322,457746,929300,1047638,943651,954266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]