SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502112 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502112 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (8985,511800,939133,780724,978424,715279,932919,927274,841788,516286,970299,733199,545749,838933,621823,849930,334351,406356,814026,367996,337527,823253,912876,503522,742794,655349,97648,885478,973188,580238,361206,943071,832071,243121,547599,83375,862958,622097,765144,961183,860802,191739,484389,338026,716601,595882,482498,588059,973237,535761,155105,140498,265716,218935,436170,335273,253536,272918,46425,849884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]