SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470715 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470715 [ RunTime:0.003006s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909435,178318,773249,1016284,892986,257060,270887,798693,66240,624764,377558,43816,508713,530511,1032111,233134,902993,602676,912007,188342,519292,714369,212286,995167,281673,1014762,886363,387873,316436,977918,126162,1011200,860011,268185,702903,894121,403155,573704,625465,432215,648369,852917,66423,313976,800,188196,240789,390860,190076,755493,993330,236637,446728,495531,246697,404523,490681,258511,774856,166285) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]