SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204572 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204572 [ RunTime:0.002465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525029,1028012,639561,1016733,36231,583291,1017915,349283,47406,712123,116571,1004531,747282,307122,241571,966326,138963,18146,666122,910395,1012817,614522,306219,883133,152778,1042138,998958,645283,154480,134916,664051,94573,591734,270204,426192,567394,949309,755048,258019,231933,839047,891571,512201,395319,18599,890392,507428,349227,2155,951764,936921,562027,343222,615123,584033,188603,773831,923751,780785,326825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204572 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204572 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]