SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394031 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394031 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50059,186229,136766,1648,294933,633642,382863,3746,74807,374612,66177,728392,245576,911349,188094,390655,970088,798928,730503,851823,580852,931202,134522,440415,916487,828518,1009455,567331,291914,647780,304531,59855,861,909394,739305,1040007,903354,274092,610669,6738,1023221,27184,92769,390731,439422,441268,199924,913696,97475,659842,354663,480183,166689,339634,450084,652551,912941,500173,376920,622533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]