SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154420 LIMIT 1 [ RunTime:0.000914s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154420 [ RunTime:0.003543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614285,740676,776956,511034,244486,900571,44043,480717,1041709,735705,761605,915412,7996,582690,392867,909062,119264,222581,212263,969863,982296,416524,275630,1000977,175941,539853,637042,807151,112842,159483,450981,908253,985067,1016134,727153,836604,590178,426471,447163,882924,110629,318424,532718,233835,83277,549535,771729,283078,188375,874123,1016198,742126,110552,469937,153922,361443,606991,997330,210932,895946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]