SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001534s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509148 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509148 [ RunTime:0.002057s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293988,889815,152723,796893,710356,906148,160562,125038,1007097,462809,829119,719863,356682,275603,992945,567319,760903,777849,713194,950955,164348,73698,550805,165849,265632,1014739,965123,941200,848152,796600,926611,456221,506781,237103,801420,332441,52392,743733,225307,556571,467165,390247,568012,292288,54951,149344,877620,267075,733569,372131,733241,347890,737283,249189,565598,1006304,51522,942634,969192,123189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]