SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 64103 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 64103 [ RunTime:0.002414s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664593,702387,171298,702335,1032818,35563,415088,383297,447331,485082,435790,302078,275133,34913,474927,658052,918339,910816,349135,687977,294330,347746,494770,464136,874205,856967,489452,36846,1039746,775428,644559,923672,824013,499910,738819,699098,262377,996650,309276,743783,8195,258342,122425,551271,840524,513011,326354,854237,827948,581602,958182,755125,863755,902128,166266,421478,478136,332042,750650,1048836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 64103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 64103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]