SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490781 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490781 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035217,9173,322944,911262,907541,967439,422547,606925,357007,179788,353901,142251,183535,337995,1004823,886601,294288,790263,420219,842235,365430,789753,684403,531970,85733,884348,782227,801750,126311,1009156,1031594,745894,1046941,674428,646354,466331,647455,436410,587887,686482,709822,405097,841426,1039227,441150,517617,148436,292648,770161,1000094,207356,130436,803725,718189,901480,939094,585386,209627,744104,375588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000818s ]