SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541496 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541496 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69545,631720,177927,76224,409163,39096,416892,229407,363424,40686,428023,36338,162715,499901,178431,183586,541372,688550,484935,433285,958665,422808,286251,1002929,134536,678821,775967,685423,243442,299416,144724,1012098,14707,404189,996326,385610,166642,492415,328868,50664,696306,809148,211521,553859,890389,66286,962584,687455,666920,351038,642321,668853,596524,311415,500177,469746,318040,797764,680628,524274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]