SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478643 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478643 [ RunTime:0.001448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113953,900820,386963,1045919,257002,129430,819572,365477,377093,90860,19591,992955,1003721,14439,354316,959155,1045830,176000,807980,602166,839832,283630,875024,748015,109051,1005119,159850,797069,764052,817482,783637,428343,226889,545204,790853,894668,510720,17474,199088,332461,780151,423226,123808,48068,100454,364416,775008,198330,820305,72605,1027618,297368,927156,657566,946558,842874,893140,631870,393215,272583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]