SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318838 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318838 [ RunTime:0.001558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754658,147501,387738,94389,515233,1005409,684824,688257,7631,905637,110238,452779,28761,421440,926019,910046,901869,441804,126804,963199,834545,165376,92808,1028828,170204,792084,120724,548472,172628,52363,678512,52646,573738,642327,43668,769625,226910,156380,36988,738041,923746,199401,826545,569795,856488,1029177,530200,855569,648971,517122,913528,195790,831470,8127,446886,51900,415645,594300,797107,5064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]