SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427950 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427950 [ RunTime:0.002102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83477,549613,374614,941692,525163,254766,850457,58492,415248,223405,1011296,678613,297888,267394,253181,881571,144392,575846,251151,229863,91944,241476,773417,298196,143797,239435,496411,813296,338813,428467,494411,382471,133029,509657,991272,452763,112616,593174,905774,655995,32427,11814,373427,39776,384468,243112,269166,802639,431334,1048148,925463,955886,692531,712267,962342,316640,37705,794241,494913,1013653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]