SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201074 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201074 [ RunTime:0.001628s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556428,500201,577781,491253,753912,1033417,1031924,862951,564529,76618,678289,477600,962544,550263,958185,979512,376845,173687,503183,74769,657505,986045,233811,246697,734318,310419,33571,638373,442227,847571,484185,89921,825112,166920,756893,792582,2728,578189,413473,294966,446786,453490,628316,469472,1002977,771514,1016788,1017561,12315,120721,204164,188433,674428,914398,939937,746733,10663,241452,1035591,842833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201074 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000713s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201074 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000861s ]