SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413494 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413494 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479465,861067,24627,471657,548422,752987,301927,922637,987708,1020178,349683,29228,1020277,712146,79999,12563,1011209,2117,594636,391517,203159,729430,920757,953023,204569,60930,973131,805660,561389,707180,362368,937242,649169,18080,676884,953497,75761,818945,360086,761117,181122,149365,545966,357927,14929,606249,439440,869898,311372,187754,190088,194081,438924,930158,944734,286380,838327,739504,792570,681889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413494 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413494 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]