SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1910 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1910 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474676,125034,331129,647751,649079,800640,869055,570988,22309,499189,532851,122332,678591,174242,685186,292359,535702,858184,485290,886136,133072,404200,820673,508556,1047239,429764,794806,812292,3638,268171,325742,1041220,939692,78311,258205,17580,596833,1034568,380797,982661,437611,206318,606563,919947,770072,522042,796563,706050,922616,823489,864119,927413,978506,168331,488224,410869,719601,894078,149621,210035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]