SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347534 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347534 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48834,939074,10654,161994,441191,469079,644493,258789,848824,427670,860465,161846,792557,996462,221929,279791,12526,571736,902978,808624,148519,11402,52877,754201,281168,545000,18683,891714,280784,1017142,319978,668960,614140,349224,406618,691335,766107,11475,929753,402013,450958,652637,832606,411170,93183,82850,362112,39205,488004,248163,999742,331617,520802,934357,378869,720383,848914,936401,980635,116340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]