SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 32104 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 32104 [ RunTime:0.002960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681193,685849,76233,273815,370996,536113,189385,704417,640583,291685,341264,260338,1037168,170900,211774,223786,449833,58823,52818,211935,1043327,419889,928652,792899,1022862,430667,97264,457224,756188,563070,559700,858272,563980,82134,18630,370757,680987,162302,149568,590723,648536,832980,217,260140,751123,528636,299126,567731,360201,435116,137972,250308,507663,499184,657924,696854,534780,23787,196979,468616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 32104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 32104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]