SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040617 LIMIT 1 [ RunTime:0.000960s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040617 [ RunTime:0.002696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518971,235736,12314,829180,532555,642479,566488,3424,357544,919642,638815,596799,91905,287618,401581,424092,451036,192185,411988,727207,79495,855103,690508,103590,1011259,844809,602005,955675,143850,738248,358490,799490,804881,920695,704567,712655,344661,391156,1043613,637494,332051,1019475,160039,694635,734989,90541,537845,336461,45933,176540,498672,636143,32878,10451,399688,368311,576061,902948,755299,386086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]