SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499856 LIMIT 1 [ RunTime:0.002543s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499856 [ RunTime:0.001027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167402,160007,126944,436888,24223,654386,1005918,92924,110940,630527,753973,557801,167486,980679,1017993,555061,1024586,934508,440414,549159,322496,607935,1028969,1001845,568182,279219,791457,495754,30641,124423,350694,562651,589205,512583,217588,590192,581651,508161,871302,214285,110284,791988,102244,639434,773574,927093,66642,25376,633393,64669,220581,610572,57001,175353,258155,840606,27621,341814,886233,145289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499856 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499856 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002107s ]