SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514573 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514573 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174932,2755,142719,152230,877503,10551,176248,680419,96484,210172,939233,539888,600872,950707,757776,953419,213943,720651,400818,884520,531335,713185,523007,461375,325080,975084,440657,848779,269244,1020835,443177,45327,669392,2889,331344,16204,315746,302367,354986,819569,8736,878605,461900,83917,856863,59655,155696,100376,236755,578949,849722,804646,476539,247307,963644,608747,407458,170484,954622,657132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]