SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542218 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542218 [ RunTime:0.002165s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547936,869002,783016,548684,363321,600306,452835,553119,689223,114832,991002,691922,569469,277519,723845,706048,386005,1017032,455662,3115,430724,883665,18000,258434,751671,807462,683147,930870,192604,9141,851753,155555,618966,274425,1008167,316216,1024384,45713,753875,588268,1001285,1043169,973957,1024779,446143,558240,985810,822112,44702,848371,531948,760260,283186,904875,625129,31995,885887,640025,842030,617106) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]