SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544881 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544881 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472722,445906,825044,912364,585747,663885,17827,409499,920998,580268,222559,318055,678136,696782,741551,446807,248728,1001097,95617,483590,866359,323725,18187,435238,820406,622216,462514,764062,931237,312144,73850,36374,83429,220206,737563,704232,280252,618102,487397,309861,836805,168552,1040247,605835,424902,737056,601563,467098,725359,777656,657801,350102,748256,888813,901,759660,1014503,1005934,270667,155651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]