SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002017s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461090 LIMIT 1 [ RunTime:0.001218s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461090 [ RunTime:0.002317s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92009,293627,605270,1035442,666636,51909,973496,97320,50942,619609,941895,610444,950129,1016434,82623,986723,951510,579158,583135,215983,545249,886389,932074,96244,434201,869472,985166,95626,172036,505847,924620,182673,312244,716331,442280,411589,791659,336461,542469,294592,916487,316950,510630,373539,163770,109260,54454,325543,517121,481598,85508,346307,606609,43075,493604,357890,25936,296895,186027,860956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]