SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019170 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019170 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469950,818334,737514,447047,215108,745462,958134,19961,1023113,163877,93932,59096,588907,148706,1036057,790336,512144,462799,498112,594121,397551,574081,4754,486140,268105,403303,953934,363670,190065,452315,833393,507258,319459,936375,699062,44779,140836,791646,455298,875778,659886,384168,338116,121994,979214,675738,438506,568365,853118,348978,789501,680605,614866,801236,630416,816746,756755,877684,508115,21558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]