SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101714 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101714 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048058,252053,119346,610801,374753,971681,594844,82111,940649,15752,900030,915574,709748,393826,183875,1041487,505203,44164,56178,759758,421333,30975,73322,829851,1016869,136813,632938,1010734,51443,1037484,102676,798732,149212,244786,1018158,613271,447176,276167,268564,143134,362531,631219,903240,12391,543026,784223,869080,675739,186451,863229,297103,43174,773592,216336,1048727,276370,419036,527073,401116,571250) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]