SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110328 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110328 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (900261,203782,944859,89240,15501,636694,739331,499054,664984,251242,749201,31920,518296,479152,166301,189353,665052,736804,671043,271360,953451,667751,40767,795530,600054,531592,305606,925954,729569,205487,346838,982985,440924,604146,725332,381276,34155,318424,1043999,887387,269369,190621,870745,896625,977817,570654,283598,683314,140537,869273,714300,36609,270166,213980,856014,758333,355794,923061,666566,565717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]