SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010599 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010599 [ RunTime:0.002600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597675,106609,12167,440485,34850,466777,1005425,172130,354583,716097,1006501,469133,881221,683166,59051,895434,98072,387988,717538,845937,870783,244284,538971,920494,417838,418151,888681,503398,213036,840596,282858,736432,614086,654260,316436,374671,697020,58316,866446,531704,218195,9382,338972,319067,885469,1023661,519088,714890,345005,936524,658640,297429,764193,474694,349665,747321,576487,177013,666885,884132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]