SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504163 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504163 [ RunTime:0.002923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987684,539573,664537,843866,268770,408725,375504,1006210,942211,664102,328388,154133,507324,570030,59679,512965,211315,773287,998522,355393,166251,635063,408993,730455,946274,547015,488640,791530,263585,519574,52983,454553,989787,929072,802970,727326,327901,1048862,568126,67315,550935,44847,689828,1039284,925726,823167,134740,911629,837366,73420,776603,430843,451915,1037860,588898,107295,240081,321097,541288,85843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504163 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504163 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001070s ]