SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407451 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407451 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80193,26410,876071,240747,347967,336953,946300,813010,32327,1022878,20420,493934,315939,180591,785789,764113,437580,709416,404976,246143,355105,369811,699365,646092,986918,232216,334043,950544,206510,251515,986134,896068,1000816,423299,403978,750423,995191,457180,33254,299755,621839,354828,289912,503243,3997,559791,117878,962506,860150,89645,427890,900462,127267,771935,989396,567587,222867,754640,388194,246945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]