SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447457 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447457 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315080,697344,153604,1006006,629820,340271,594307,200464,658727,815144,444635,67231,304059,768091,205104,570845,194453,393707,544505,167816,603967,420540,30557,466710,751965,195840,405297,204708,349784,1020617,683894,650714,1011663,1167,316169,628512,449404,212854,272855,371773,224590,524404,386234,140822,494003,544257,702408,270290,795622,387117,463809,743372,787819,10162,333049,974696,972593,844256,600099,943808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]