SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001726s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519478 LIMIT 1 [ RunTime:0.000595s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519478 [ RunTime:0.004363s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4661,1013360,188086,404425,1013060,86184,512224,210107,646718,389550,220184,809417,222211,732375,243049,602975,222778,903587,205912,934520,435828,829815,350269,46925,188245,745576,599065,374424,740531,462949,738564,277099,494440,404628,538776,781733,824820,638998,462569,34905,512674,564121,59774,918377,911397,311124,436047,402736,367248,881829,1001529,920584,156380,423411,180933,728953,383322,943008,206417,714453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]