SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001804s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505740 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505740 [ RunTime:0.002463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135216,306366,107435,1010058,914323,85685,27769,293071,450654,939860,397538,470493,111752,363083,607828,1006815,476293,678756,338266,990900,1029981,769603,240926,130251,55568,964604,35573,837078,168685,790874,471503,844364,322811,293726,830104,473166,73963,390470,77992,772929,230311,1034412,874485,105014,963538,841292,434740,897196,1008520,460584,965413,802714,159478,30461,86994,60356,807989,1000363,112950,320043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]