SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 645513 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 645513 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (957501,71059,112041,817600,864428,60405,195509,762328,181103,834058,278428,1027310,387260,722498,705513,254123,36657,664450,363175,604459,125166,852017,774106,90721,268643,579501,258648,1012579,41929,369791,251058,80716,731503,149154,637608,876664,898529,526713,496756,817950,1048811,400508,706856,124669,596263,250389,246367,643686,1026717,904578,644929,395548,1007542,269104,496130,483817,146802,369386,807577,229959) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 645513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 645513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]