SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200467 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200467 [ RunTime:0.002172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (302198,534645,1020614,728557,13133,483288,356765,251131,595124,563081,407154,32751,653952,270726,117618,560013,69547,15559,859440,375257,202453,441202,897906,675276,317111,787799,168222,85869,498803,708848,821713,245320,1006945,427492,550419,1035305,498264,1012323,985919,406529,603027,971384,226558,458844,959621,344327,318977,692105,305597,611100,754571,679433,599891,11269,524698,101051,681620,417120,869333,480286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200467 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200467 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]