SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532969 LIMIT 1 [ RunTime:0.000498s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532969 [ RunTime:0.003895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429450,145713,545,23011,428990,1013450,89015,362053,455147,939251,166365,713525,1026933,768012,465483,416814,279731,532216,201833,587364,929816,130627,254084,737019,594469,787538,615546,586987,272879,905754,504580,706975,871043,958901,250722,272688,904808,634297,526405,273178,270384,648953,234470,377525,834553,532816,403847,400267,684430,40165,490923,928996,381395,794320,498182,918773,500849,523679,522572,42155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]